package com.bupt.ilink.mapper.innovationPlaza;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bupt.ilink.entity.innovationPlaza.UserMetadata;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigInteger;
import java.util.List;

@Mapper
public interface UserMetadataMapper extends BaseMapper<UserMetadata> {

    @Select("SELECT um.user_image FROM user_metadata um " +
            "JOIN project_user pu ON um.user_id = pu.user_id " +
            "WHERE pu.project_id = #{projectId}")
    List<byte[]> getUserImagesByProjectId(BigInteger projectId);
}

